National_Pride_Large

	Data/import.do:246
	Data/import.do:261
→	Data/EVC_da..a_Taxing_Wages2013.csv	↘
	Data/import.do:245		Data/EVC_da..a_Taxing_Wages2013.csv Data/EVC_da..a_Taxing_Wages2013.dta

Data/EVC_data/OECD data/taxing_wages/AWCOMP_Data_Taxing_Wages2013.csv open
file:data:csv

All properties
key	content
N	58576
_runCommand	import delimited
datasignature	58576:9(41708):1608947872:817554313
date	Tue Oct 21 00:19:54 EST 2014
lastmodified	1413814794000
variables	9

Variable Graph Type N Descriptives Label

[+] country
@AWCOMP_Data_Taxing_Wages2013.csv

string
(str15)

58576
(35)

Country

All properties
key	content
N	58576
N_unique	35
class	string
example0	Australia
label	Country
type	str15

Data Manipulations with country
file	#	command

Script Output

@example0 Australia
@type str15
@label Country
@class string
@N_unique 35
@N 58576

[+] familytype
@AWCOMP_Data_Taxing_Wages2013.csv

category
(str92)

58576
(8)

"One-earner married couple at 100.. %, 2 children"

Family type

All properties
key	content
N	58576
N_unique	8
class	category
freq	7322, 7322, 7322, 7322, 7322, 7322, 7322, 7322
label	Family type
type	str92
values	"One-earner married couple at 100% of average earnings, 2 children", "Single person at 100% of average earnings, no child", "Single person at 167% of average earnings, no child", "Single person at 67% of average earnings, no child", "Single person at 67% of average earnings, with two children", "Two-earner married couple, one at 100% of average earnings and the other at 33 %, 2 children", "Two-earner married couple, one at 100% of average earnings and the other at 33 %, no child", "Two-earner married couple, one at 100% of average earnings and the other at 67 %, 2 children"

Data Manipulations with familytype
file	#	command

Script Output

@freq 7322, 7322, 7322, 7322, 7322, 7322, 7322, 7322
@values "One-earner married couple at 100% of average earnings, 2 children", "Single person at 100% of average earnings, no child", "Single person at 167% of average earnings, no child", "Single person at 67% of average earnings, no child", "Single person at 67% of average earnings, with two children", "Two-earner married couple, one at 100% of average earnings and the other at 33 %, 2 children", "Two-earner married couple, one at 100% of average earnings and the other at 33 %, no child", "Two-earner married couple, one at 100% of average earnings and the other at 67 %, 2 children"
@type str92
@label Family type
@class category
@N_unique 8
@N 58576

[+] flags
@AWCOMP_Data_Taxing_Wages2013.csv

empty
(byte)

0
(0)

Flags

All properties
key	content
N	0
N_unique	0
class	empty
example0	.
label	Flags
mean	.
type	byte

Data Manipulations with flags
file	#	command

Script Output


flags:  Flags                                   Number of Observations
-------------                               ------------------------------
                                            Total   Integers   Nonintegers
|                            Negative           -         -          -
|                            Zero               -         -          -
|                            Positive           -         -          -
|                                           -----     -----      -----
|                            Total              -         -          -
|                            Missing        58576
+----------------------                     -----
.             -9.0e+307                     58576
   (0 unique value)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
       flags |         0
@mean         .
@sd 
@min 
@max 
@example0 .
@type byte
@label Flags
@class empty
@N_unique 0
@N 0

[+] indicator
@AWCOMP_Data_Taxing_Wages2013.csv

category
(str80)

58576
(15)

"Average income tax rate", "Avera..exchange rates"

Indicator

All properties
key	content
N	58576
N_unique	15
class	category
freq	3920, 3920, 3920, 3920, 3920, 3920, 3920, 3920, 3920, 3808, 3920, 3920, 3920, 3808, 3920
label	Indicator
type	str80
values	"Average income tax rate", "Average rate of employees' social security contributions", "Average rate of employer's social security contributions", "Average rate of income tax and employees' social security contributions", "Average tax wedge", "Increase in net income after an increase of 1 currency unit in gross labour cost", "Increase in net income after an increase of 1 currency unit in gross wages", "Marginal tax wedge: Principal earner", "Net income after taxes in US dollars using PPP exchange rates", "Net income after taxes in national currency", "Net personal average tax rate", "Net personal marginal tax rate: Principal earner", "Total gross earnings before taxes in US dollars using PPP exchange rates", "Total gross earnings before taxes in national currency", "Total gross labour costs before taxes in US dollars using PPP exchange rates"

Data Manipulations with indicator
file	#	command

Script Output

@freq 3920, 3920, 3920, 3920, 3920, 3920, 3920, 3920, 3920, 3808, 3920, 3920, 3920, 3808, 3920
@values "Average income tax rate", "Average rate of employees' social security contributions", "Average rate of employer's social security contributions", "Average rate of income tax and employees' social security contributions", "Average tax wedge", "Increase in net income after an increase of 1 currency unit in gross labour cost", "Increase in net income after an increase of 1 currency unit in gross wages", "Marginal tax wedge: Principal earner", "Net income after taxes in US dollars using PPP exchange rates", "Net income after taxes in national currency", "Net personal average tax rate", "Net personal marginal tax rate: Principal earner", "Total gross earnings before taxes in US dollars using PPP exchange rates", "Total gross earnings before taxes in national currency", "Total gross labour costs before taxes in US dollars using PPP exchange rates"
@type str80
@label Indicator
@class category
@N_unique 15
@N 58576

[+] powercode
@AWCOMP_Data_Taxing_Wages2013.csv

constant
(str5)

58576
(1)

"Units"

Power code

All properties
key	content
N	58576
N_unique	1
class	constant
example0	Units
freq	58576
label	Power code
type	str5
values	"Units"

Data Manipulations with powercode
file	#	command

Script Output

@freq 58576
@values "Units"
@example0 Units
@type str5
@label Power code
@class constant
@N_unique 1
@N 58576

[+] referenceperiod
@AWCOMP_Data_Taxing_Wages2013.csv

empty
(byte)

0
(0)

Reference period

All properties
key	content
N	0
N_unique	0
class	empty
example0	.
label	Reference period
mean	.
type	byte

Data Manipulations with referenceperiod
file	#	command

Script Output


referenceperiod:  Reference period              Number of Observations
----------------------------------          ------------------------------
                                            Total   Integers   Nonintegers
|                            Negative           -         -          -
|                            Zero               -         -          -
|                            Positive           -         -          -
|                                           -----     -----      -----
|                            Total              -         -          -
|                            Missing        58576
+----------------------                     -----
.             -9.0e+307                     58576
   (0 unique value)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
referencep~d |         0
@mean         .
@sd 
@min 
@max 
@example0 .
@type byte
@label Reference period
@class empty
@N_unique 0
@N 0

[+] unitofmeasureused
@AWCOMP_Data_Taxing_Wages2013.csv

category
(str18)

58576
(21)

"Australian Dollar", "Canadian Do.. "Yen", "Zloty"

Unit of measure used

All properties
key	content
N	58576
N_unique	21
class	category
freq	224, 224, 224, 224, 224, 3360, 224, 224, 224, 224, 224, 224, 39200, 224, 224, 224, 224, 11984, 224, 224, 224
label	Unit of measure used
type	str18
values	"Australian Dollar", "Canadian Dollar", "Chilean Peso", "Czech Koruna", "Danish Krone", "Euro", "Forint", "Iceland Krona", "Mexican Peso", "New Israeli Sheqel", "New Zealand Dollar", "Norwegian Krone", "Percentage", "Pound Sterling", "Swedish Krona", "Swiss Franc", "Turkish Lira", "US Dollar", "Won", "Yen", "Zloty"

Data Manipulations with unitofmeasureused
file	#	command

Script Output

@freq 224, 224, 224, 224, 224, 3360, 224, 224, 224, 224, 224, 224, 39200, 224, 224, 224, 224, 11984, 224, 224, 224
@values "Australian Dollar", "Canadian Dollar", "Chilean Peso", "Czech Koruna", "Danish Krone", "Euro", "Forint", "Iceland Krona", "Mexican Peso", "New Israeli Sheqel", "New Zealand Dollar", "Norwegian Krone", "Percentage", "Pound Sterling", "Swedish Krona", "Swiss Franc", "Turkish Lira", "US Dollar", "Won", "Yen", "Zloty"
@type str18
@label Unit of measure used
@class category
@N_unique 21
@N 58576

[+] value
@AWCOMP_Data_Taxing_Wages2013.csv

other
(float)

58576
(.)

(x̄=2.10e+05, 2.31e+06) [-45.062,6.64e+07]

Value

All properties
key	content
N	58576
N_unique	.
class	other
example0	42040.805
histh	6.952e-07, 2.550e-09, 2.973e-09, 2.019e-09, 1.475e-09, 7.252e-10, 2.417e-10, 9.670e-11, 2.417e-11, 7.252e-11, 4.835e-11, 7.252e-11, 7.252e-11, 8.461e-11, 1.450e-10, 1.088e-10, 1.088e-10, 1.330e-10, 1.209e-10, 7.252e-11, 9.670e-11, 1.209e-10, 7.252e-11, 1.450e-10, 9.670e-11, 7.252e-11, 6.044e-11, 1.209e-10, 7.252e-11, 7.252e-11, 6.044e-11, 8.461e-11, 7.252e-11, 3.626e-11, 9.670e-11, 3.626e-11, 4.835e-11, 3.626e-11, 3.626e-11, 6.044e-11, 2.417e-11, 2.417e-11, 4.835e-11, 2.417e-11, 2.417e-11
histw	706154.94, 2118554.8, 3530954.8, 4943354.5, 6355754.5, 7768154.5, 9180555, 10592954, 12005354, 13417754, 14830154, 16242554, 17654954, 19067354, 20479754, 21892154, 23304554, 24716954, 26129354, 27541754, 28954154, 30366554, 31778954, 33191354, 34603752, 36016152, 37428552, 38840952, 40253352, 41665752, 43078152, 44490552, 45902952, 47315352, 48727752, 50140152, 51552552, 52964952, 54377352, 55789752, 57202152, 58614552, 61439352, 64264152, 65676552
label	Value
max	6.64e+07
mean	2.10e+05
min	-45.062
sd	2.31e+06
type	float

Data Manipulations with value
file	#	command

Script Output


value:  Value                                   Number of Observations
-------------                               ------------------------------
                                            Total   Integers   Nonintegers
|  #                         Negative         433         -        433
|  #                         Zero             728       728          -
|  #                         Positive       57415      4073      53342
|  #                                        -----     -----      -----
|  #                         Total          58576      4801      53775
|  #   .   .   .   .         Missing            -
+----------------------                     -----
-45.062        6.64e+07                     58576
(More than 99 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
       value |     58576    209717.3     2305620    -45.062   6.64e+07
@mean  2.10e+05
@sd  2.31e+06
@min   -45.062
@max  6.64e+07
@example0 42040.805
@histh 6.952e-07, 2.550e-09, 2.973e-09, 2.019e-09, 1.475e-09, 7.252e-10, 2.417e-10, 9.670e-11, 2.417e-11, 7.252e-11, 4.835e-11, 7.252e-11, 7.252e-11, 8.461e-11, 1.450e-10, 1.088e-10, 1.088e-10, 1.330e-10, 1.209e-10, 7.252e-11, 9.670e-11, 1.209e-10, 7.252e-11, 1.450e-10, 9.670e-11, 7.252e-11, 6.044e-11, 1.209e-10, 7.252e-11, 7.252e-11, 6.044e-11, 8.461e-11, 7.252e-11, 3.626e-11, 9.670e-11, 3.626e-11, 4.835e-11, 3.626e-11, 3.626e-11, 6.044e-11, 2.417e-11, 2.417e-11, 4.835e-11, 2.417e-11, 2.417e-11
@histw 706154.94, 2118554.8, 3530954.8, 4943354.5, 6355754.5, 7768154.5, 9180555, 10592954, 12005354, 13417754, 14830154, 16242554, 17654954, 19067354, 20479754, 21892154, 23304554, 24716954, 26129354, 27541754, 28954154, 30366554, 31778954, 33191354, 34603752, 36016152, 37428552, 38840952, 40253352, 41665752, 43078152, 44490552, 45902952, 47315352, 48727752, 50140152, 51552552, 52964952, 54377352, 55789752, 57202152, 58614552, 61439352, 64264152, 65676552
@type float
@label Value
@class other
@N_unique .
@N 58576

[+] year
@AWCOMP_Data_Taxing_Wages2013.csv

category
(int)

58576
(14)

"2000", "2001", "2002", "2003", ".. "2012", "2013"

Year

All properties
key	content
N	58576
N_unique	14
class	category
freq	4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184
label	Year
max	2013
mean	2006.500
min	2000
names	"2000", "2001", "2002", "2003", "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011", "2012", "2013"
sd	4.031
type	int
values	2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013

Data Manipulations with year
file	#	command

Script Output


year:  Year                                     Number of Observations
-----------                                 ------------------------------
                                            Total   Integers   Nonintegers
|  #   #       #   #         Negative           -         -          -
|  #   #       #   #         Zero               -         -          -
|  #   #   #   #   #         Positive       58576     58576          -
|  #   #   #   #   #                        -----     -----      -----
|  #   #   #   #   #         Total          58576     58576          -
|  #   #   #   #   #         Missing            -
+----------------------                     -----
2000               2013                     58576
  (14 unique values)

    Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
        year |     58576      2006.5    4.031163       2000       2013
@mean  2006.500
@sd     4.031
@min      2000
@max      2013
@values 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013
@names "2000", "2001", "2002", "2003", "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011", "2012", "2013"
@freq 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184, 4184
@type int
@label Year
@class category
@N_unique 14
@N 58576

Content



>  * A do file to run the standard stats for a whole data set. 
>  *
>  * Note that you must delete the files in the derived directory
>  * for changes to be reflected in the output.
>  *
>  * @version 0.1
> */
(9 vars, 58576 obs). 

Contains data
  obs:        58,576                          
 vars:             9                          
 size:    12,769,568                          
Sorted by:  
     Note:  dataset has changed since last saved
@N 58576
@variables 9
  58576:9(41708):1608947872:817554313
@datasignature 58576:9(41708):1608947872:817554313
panel variable not set; use xtset varname ...
.

- - Tokens
    AWCOMP AWCOMP Data csv Data Data Taxing Taxing Taxing Wages Wages Wages 2013 2013 2013 csv

File AWCOMP_Data_Taxing_Wages2013.csv

Script Output

Script Output

Script Output

Script Output

Script Output

Script Output

Script Output

Script Output

Script Output

Content

Tokens